Tabela CO_RECIPEINGREDIENT

Definicja tabeli CO_RECIPEINGREDIENT

Name

CO_RECIPEINGREDIENT

Code

CO_RECIPEINGREDIENT

Comment

 


Lista kolumn tabeli CO_RECIPEINGREDIENT

Name

Code

CO_RECIPEINGREDIENTID

CO_RECIPEINGREDIENTID

CO_DICTPRODUCTID

CO_DICTPRODUCTID

QUANTITYIN

QUANTITYIN

QUANTITYOUT

QUANTITYOUT

CO_RECIPEID

CO_RECIPEID

CO_DICTUNITID

CO_DICTUNITID

CO_DICTPRODUCTPROCESSINGID

CO_DICTPRODUCTPROCESSINGID

INSERTDATE

INSERTDATE

INSERTINGPERSON

INSERTINGPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDDT

LASTMODIFIEDDT


Kolumna CO_RECIPEINGREDIENTID tabeli CO_RECIPEINGREDIENT

Definicja kolumny CO_RECIPEINGREDIENTID tabeli CO_RECIPEINGREDIENT

Name

CO_RECIPEINGREDIENTID

Code

CO_RECIPEINGREDIENTID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna CO_DICTPRODUCTID tabeli CO_RECIPEINGREDIENT

Definicja kolumny CO_DICTPRODUCTID tabeli CO_RECIPEINGREDIENT

Name

CO_DICTPRODUCTID

Code

CO_DICTPRODUCTID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna QUANTITYIN tabeli CO_RECIPEINGREDIENT

Definicja kolumny QUANTITYIN tabeli CO_RECIPEINGREDIENT

Name

QUANTITYIN

Code

QUANTITYIN

Data Type

NUMBER(20,8)

Mandatory

Yes

Comment

 


Kolumna QUANTITYOUT tabeli CO_RECIPEINGREDIENT

Definicja kolumny QUANTITYOUT tabeli CO_RECIPEINGREDIENT

Name

QUANTITYOUT

Code

QUANTITYOUT

Data Type

NUMBER(20,8)

Mandatory

Yes

Comment

 


Kolumna CO_RECIPEID tabeli CO_RECIPEINGREDIENT

Definicja kolumny CO_RECIPEID tabeli CO_RECIPEINGREDIENT

Name

CO_RECIPEID

Code

CO_RECIPEID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CO_DICTUNITID tabeli CO_RECIPEINGREDIENT

Definicja kolumny CO_DICTUNITID tabeli CO_RECIPEINGREDIENT

Name

CO_DICTUNITID

Code

CO_DICTUNITID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CO_DICTPRODUCTPROCESSINGID tabeli CO_RECIPEINGREDIENT

Definicja kolumny CO_DICTPRODUCTPROCESSINGID tabeli CO_RECIPEINGREDIENT

Name

CO_DICTPRODUCTPROCESSINGID

Code

CO_DICTPRODUCTPROCESSINGID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna INSERTDATE tabeli CO_RECIPEINGREDIENT

Definicja kolumny INSERTDATE tabeli CO_RECIPEINGREDIENT

Name

INSERTDATE

Code

INSERTDATE

Data Type

DATE

Mandatory

No

Comment

 


Kolumna INSERTINGPERSON tabeli CO_RECIPEINGREDIENT

Definicja kolumny INSERTINGPERSON tabeli CO_RECIPEINGREDIENT

Name

INSERTINGPERSON

Code

INSERTINGPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDPERSON tabeli CO_RECIPEINGREDIENT

Definicja kolumny LASTMODIFIEDPERSON tabeli CO_RECIPEINGREDIENT

Name

LASTMODIFIEDPERSON

Code

LASTMODIFIEDPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDDT tabeli CO_RECIPEINGREDIENT

Definicja kolumny LASTMODIFIEDDT tabeli CO_RECIPEINGREDIENT

Name

LASTMODIFIEDDT

Code

LASTMODIFIEDDT

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli CO_RECIPEINGREDIENT

Name

Code

Primary

PK_CO_RECIPEINGREDIENT

PK_CO_RECIPEINGREDIENT

X


Klucz PK_CO_RECIPEINGREDIENT tabeli CO_RECIPEINGREDIENT

Definicja klucza PK_CO_RECIPEINGREDIENT tabeli CO_RECIPEINGREDIENT

Name

PK_CO_RECIPEINGREDIENT

Code

PK_CO_RECIPEINGREDIENT

Primary

Yes

Comment